UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XRWychxlWY1CEA8Ap7zxGAeLoNreISIDMvo6eY0FRkA='
WHERE
key_id = '97eaea7a10f9a2ed6906134dc948a0f5c8a0f42ce67a718464cd43b3de1c4035'
AND (
token = 'XRWychxlWY1CEA8Ap7zxGAeLoNreISIDMvo6eY0FRkA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)