UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r07R0ijLu3xszaS7oMt/rO9+VH9bbN0AOS4o7tP1tNY='
WHERE
key_id = '00d7f81468c2b5a6f1de148c44e6a65f8dcc295c32eb0368a4f2fad62b6b3478'
AND (
token = 'r07R0ijLu3xszaS7oMt/rO9+VH9bbN0AOS4o7tP1tNY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)