UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KHaA50i2K0N7PmtwhCkfBTdT93e+/U5mBxNS69ojsJI='
WHERE
key_id = 'ef78870ca630a497ed268b7c5bd4d4792edaf387bb979b03171987469ac70ca1'
AND (
token = 'KHaA50i2K0N7PmtwhCkfBTdT93e+/U5mBxNS69ojsJI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)