UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3AnK66n6WySvcYNoPBgVroSOvlld5KOfGbMNkqXcArM='
WHERE
key_id = '0cdc6f16ce600e4aec08a8d40c70ba8e4c40f88989b6d0af4c36644a61766be7'
AND (
token = '3AnK66n6WySvcYNoPBgVroSOvlld5KOfGbMNkqXcArM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)