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