UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZZdAyxlV2Li2kU+VhHVApSz0AO+lfvVFjUzx52CmVSY='
WHERE
key_id = 'cd101725eee8d3c585d096e10e3023e76e0a3d39df63eb2c5fe18498bee0eaa2'
AND (
token = 'ZZdAyxlV2Li2kU+VhHVApSz0AO+lfvVFjUzx52CmVSY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)