UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8GbyH0UAKUPwDLOocvW8KaAwLpKFCUAcjs6lq4CPvfk='
WHERE
key_id = '3963461f37bd4d4675dfe6a4d5706721a880ddda750aef3fedf79d08420a9ba0'
AND (
token = '8GbyH0UAKUPwDLOocvW8KaAwLpKFCUAcjs6lq4CPvfk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)