UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pGPd17/rn3Iw/eJ7nQREckqym+WVPbZPPK7J5ogfFiQ='
WHERE
key_id = 'd7a2ce549925e815aaee2f9055bdc7f474a1b576d1bcf49270830c4ee37b33f9'
AND (
token = 'pGPd17/rn3Iw/eJ7nQREckqym+WVPbZPPK7J5ogfFiQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)