UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JDDVbkiWr4OxlFcw+KWihTKWdR/HUGCfje/oU0BuL/k='
WHERE
key_id = '0f46ee3453fec4d0ae3b59d4c2d4a6e141b50f8e5dad4f310eee48eecaf660df'
AND (
token = 'JDDVbkiWr4OxlFcw+KWihTKWdR/HUGCfje/oU0BuL/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)