UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hk/FbiaCok4ILeZsTv9ayNtQ7q0RZq6017MqMbxATyw='
WHERE
key_id = 'af915e79dec7d9cf80f3486dbf001d1a3a9ef26cc5949aa303a487d483bc848c'
AND (
token = 'hk/FbiaCok4ILeZsTv9ayNtQ7q0RZq6017MqMbxATyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)