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