UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/NnHl2gJpGBPIN85rThXYzqfrUztsCTxTFPwlESA40s='
WHERE
key_id = 'ba22d499114d2c842b8ebb00bf50ae59de3d6b0ead481899808f58165fc90ec1'
AND (
token = '/NnHl2gJpGBPIN85rThXYzqfrUztsCTxTFPwlESA40s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)