UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z39A4Z7e5foNlei9TRqn2EdIjdaaAo49kp2N05t1CR8='
WHERE
key_id = '75a5bcda33e8271c618fc5578444b053180f9b265c802359b99948d613037f9b'
AND (
token = 'z39A4Z7e5foNlei9TRqn2EdIjdaaAo49kp2N05t1CR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)