UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cK4JoIMmfn6DFFKZgXISlgXZ3bP1X6XttSxzsuja1v8='
WHERE
key_id = 'd6994bf0503541fd491edf0a6166337c2ae407ed24da73f98c8e64b6719e93a7'
AND (
token = 'cK4JoIMmfn6DFFKZgXISlgXZ3bP1X6XttSxzsuja1v8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)