UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CW5yv3NdiZIi/xKd3fDPx19JrUg9mv4piED8VBaFbw4='
WHERE
key_id = '00cf00d0400cb5f8be49a51db6a7486928d05448b9c9b1d656e6d2a5bdd63aab'
AND (
token = 'CW5yv3NdiZIi/xKd3fDPx19JrUg9mv4piED8VBaFbw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)