UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T0fAsRYRWLeOGR1pt71ddidX01D97cVWBBRW4Wd4GLs='
WHERE
key_id = '477233a9579dc2a2d5e85d57f397d2f8e89aa11b2c3c7c5f2c11991d16ecaf8a'
AND (
token = 'T0fAsRYRWLeOGR1pt71ddidX01D97cVWBBRW4Wd4GLs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)