UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uFtJJAeghx1gmYs5x4q67w20A9jNqIbJfnvJB5BE1Qs='
WHERE
key_id = '8dafe4396864d8cd3651e7d7493cc01d5d444989d4eda33a75701e90fcf9084a'
AND (
token = 'uFtJJAeghx1gmYs5x4q67w20A9jNqIbJfnvJB5BE1Qs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)