UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GVE9yNTjZF1oB/+E2GTWq14o0bmVRdB0lkb1LukGH2M='
WHERE
key_id = 'e7a786bc21370cd7fefeaa962bcbeea51d32ae5b4d457d28afd3b983ef36942f'
AND (
token = 'GVE9yNTjZF1oB/+E2GTWq14o0bmVRdB0lkb1LukGH2M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)