UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B7sBh7B+zvINE8FjKJARNXTSAVeJlp6safrdXsUX/YM='
WHERE
key_id = '6bbb97af6485f7f785fd9647bcad5449c88b091007bd35ade75dea4344b92df6'
AND (
token = 'B7sBh7B+zvINE8FjKJARNXTSAVeJlp6safrdXsUX/YM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)