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