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