UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CzsXi4hx4J1rqekqi74JD0mKIRhn4vgjR2iP9kX+0Kk='
WHERE
key_id = '9b81a7117d7c4554b9b8c5d4519fea339b95e7eba4aa3a245087444a8c18b51b'
AND (
token = 'CzsXi4hx4J1rqekqi74JD0mKIRhn4vgjR2iP9kX+0Kk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)