UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yK676cskDNKm4Yz2cpizhbH2y/23/B+6dhve1RKatPU='
WHERE
key_id = '0c2455fe142fd5f45acba42fae4e9053d22cb3042287f9500b7b059ff45a3a3c'
AND (
token = 'yK676cskDNKm4Yz2cpizhbH2y/23/B+6dhve1RKatPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)