UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7KEDTvsGwVQ8GebHEzV9lmukwoX0ku4Kgx6njzSaWcc='
WHERE
key_id = '182dab43226f54d3b9efac13f7ff196020b5fcbdd4858f6e3af344ad5541a136'
AND (
token = '7KEDTvsGwVQ8GebHEzV9lmukwoX0ku4Kgx6njzSaWcc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)