UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yVYu+ekjhNmm0bfPsWF5LyO3FGGz23khMp4nj/wiTdU='
WHERE
key_id = '5eb266c825c86eb53e17fe0b07e87aa786a5631fd3a92976babf57f54b68d9a9'
AND (
token = 'yVYu+ekjhNmm0bfPsWF5LyO3FGGz23khMp4nj/wiTdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)