UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VpzMGKdTWIBUv55hOOwouJ1iu7v8Xy8n3J59guQDWHc='
WHERE
key_id = 'a244eef05e68f1202e540022c617481a91b44b77d861089066ec9f1ad05990fd'
AND (
token = 'VpzMGKdTWIBUv55hOOwouJ1iu7v8Xy8n3J59guQDWHc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)