UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qLK3r/HW222zcmbfXIsE+fOX3+SZXM0ZgAA45B9+s1U='
WHERE
key_id = '94aead8f2474180f6cd9ba36287987ec4b5baf53f7e9ea9763f32a29b8fa0a39'
AND (
token = 'qLK3r/HW222zcmbfXIsE+fOX3+SZXM0ZgAA45B9+s1U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)