UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XMxtpZLyEosWlTx/HAU3zp1G1uX6PT1NSRrm5jt0hKE='
WHERE
key_id = 'cf0918cdda1182ab3adb5573d1f38814e9d90e345b0f9b1f51e288e1fdeff332'
AND (
token = 'XMxtpZLyEosWlTx/HAU3zp1G1uX6PT1NSRrm5jt0hKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)