UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vvb9dBofkSlBy91h1osJ3XrsHdvXpvmtF0IByBG4WsA='
WHERE
key_id = '7b7cabc668034371b06a1682670bbe9d3f0f8c4ff3fa101df99a18a9331329a2'
AND (
token = 'vvb9dBofkSlBy91h1osJ3XrsHdvXpvmtF0IByBG4WsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)