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