UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/2Og1nPdFaMhs3xiRA6kotdthsQ9EkjnwrKA9SkHA20='
WHERE
key_id = '99aa9e723ce0e6fb49cf3adedf8d70c3735d86c6f1ed9c0fe2ff82d42dff85de'
AND (
token = '/2Og1nPdFaMhs3xiRA6kotdthsQ9EkjnwrKA9SkHA20='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)