UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DM8IFvlylYc/+exdYWLwmGg7YjwIeGMTKcxETszUGIs='
WHERE
key_id = '142bb548aa1669aa7b0aa291b93f394999b6943814475a949d66b48ee95d9303'
AND (
token = 'DM8IFvlylYc/+exdYWLwmGg7YjwIeGMTKcxETszUGIs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)