UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dkXmJd7prh5OWT93Z0sbA1qJIJwvffFrH5ECaVguQKQ='
WHERE
key_id = '99470bedb20bb58b94d9c03cbf39603ca4f6dffad8de0bc32635cef46c40715e'
AND (
token = 'dkXmJd7prh5OWT93Z0sbA1qJIJwvffFrH5ECaVguQKQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)