UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X4vRufTLOCvFbK8QKPmFGC16AYIy9sokFTa44YWSEgw='
WHERE
key_id = '2ad5eacabc7dc44fab9de0ca864d9f8d17c10804a36e71964acd5b42ae911182'
AND (
token = 'X4vRufTLOCvFbK8QKPmFGC16AYIy9sokFTa44YWSEgw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)