UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vgjafXefsGA38pFTGzFaNOJ06MHU0X81rPKeVWGrTTg='
WHERE
key_id = '3178555673430d8484e615d8218b9f4dc8baa0a3d5339bf56e479f01c0c07b47'
AND (
token = 'vgjafXefsGA38pFTGzFaNOJ06MHU0X81rPKeVWGrTTg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)