UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aNBrTz7xT1ndJsoLkDUy2UJOIwMDL1K5qaDsdJ7+yPM='
WHERE
key_id = 'a498946cf2d0707390dd3942775f67897b9f87760e8ba69f37727a8cf37eca4c'
AND (
token = 'aNBrTz7xT1ndJsoLkDUy2UJOIwMDL1K5qaDsdJ7+yPM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)